|
|
|
|
|
if(isset($patternname)){
if($tbl == 'designedPattern'){
$sql = "SELECT p.* , i.position AS URL, i.description AS image_description
FROM archive_designed_pattern p JOIN archive_image_file i
ON p.id = i.owner_id WHERE p.name = '".$patternname."'";
/*$sql = "SELECT p.* , i.position AS URL, i.description AS image_description,
dp.designer, di.position as design_URL, di.description AS designed_image_description
FROM ((archive_pattern p JOIN archive_image_file i ON p.id = i.owner_id)
LEFT JOIN archive_designed_pattern dp ON p.designed_pattern_id = dp.id)
LEFT JOIN archive_image_file di ON dp.id = di.owner_id
WHERE p.name = '".$patternname."'";*/
}
else
{
$sql = "SELECT p.* , i.position AS URL, i.description AS image_description
FROM archive_pattern p JOIN archive_image_file i
ON p.id = i.owner_id WHERE p.name = '".$patternname."'";
}
}else if(isset($patternid)){
if($tbl == 'designedPattern'){
$sql = "SELECT p.* , i.position AS URL, i.description AS image_description
FROM archive_designed_pattern p JOIN archive_image_file i
ON p.id = i.owner_id WHERE p.id = '".$patternid."'";
/*$sql = "SELECT p.* , i.position AS URL, i.description AS image_description,
dp.designer, di.position as design_URL, di.description AS designed_image_description
FROM ((archive_pattern p JOIN archive_image_file i ON p.id = i.owner_id)
LEFT JOIN archive_designed_pattern dp ON p.designed_pattern_id = dp.id)
LEFT JOIN archive_image_file di ON dp.id = di.owner_id
WHERE p.id = '".$patternid."'";*/
}
else
{
$sql = "SELECT p.* , i.position AS URL, i.description AS image_description
FROM archive_pattern p JOIN archive_image_file i
ON p.id = i.owner_id WHERE p.id = '".$patternid."'";
}
}
$p_result = mysql_query($sql);
$p = mysql_fetch_array($p_result);
for ( $p_counter = 1; $p_counter <= mysql_num_rows($p_result); $p_counter += 1 ) {
$p_name = $p["name"];
$p_desc = $p["description"];
$p_url = strstr($p["URL"],'\images');
$p_url = $_SESSION["url"] . $p_url;
$p_url = str_replace("\\","/","$p_url");
$p_img_desc = $p["image_description"];
$p_designer = $p["designer"];
$p_design_url = strstr($p["design_URL"],'\images');
$p_design_url = $_SESSION["url"] . $p_design_url;
$p_design_url = str_replace("\\","/","$p_design_url");
$p_design_img_desc = $p["designed_image_description"];
$p_desc = str_replace("\n","\n ","$p_desc");
$p_desc = str_replace(" "," ","$p_desc");
?>
print $p_img_desc?>
|
print $p_name ?>
if($p_designer!=null){
?>
ออกแบบโดย
}
?>
print $p_desc ?>
$a_sql = "SELECT * FROM archive_material
WHERE pattern_id = '". $patternid."'";
$a_result = mysql_query($a_sql);
for ($a_counter = 1; $a_counter <= mysql_num_rows($a_result); $a_counter += 1 ) {
$a = mysql_fetch_array($a_result);
$a_name = $a["name"];
if($a_counter==1){
?>
วัสดุที่ใช้ :
}else{
?>
,
}
}
?>
|
if($p_design_url!=null){
?>
}
?>
|
if($p_counter != mysql_num_rows($p_result)){
?>
|
}// End if for short partition
?>
|
$p = mysql_fetch_array($p_result);
}//Character loop
?>
|
Copyright 2008 : The Fine Arts Department, Thailand
Update at : 15:49 NOV 1, 2008
|
|
|